<?php

namespace App\Jobs\Publish;

use App\Classes\Publish\Publication;
use App\Models\Entity\Asset\Vlive\Vchan;
use App\Models\Entity\Asset\Vlive\VchanVccattag;
use App\Models\Task\Task;
use Illuminate\Bus\Queueable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Foundation\Bus\Dispatchable;
use Illuminate\Support\Facades\DB;

class VchanJob implements ShouldQueue
{
    use Dispatchable, InteractsWithQueue, Queueable, SerializesModels;
    protected $ids;
    protected $option;
    public $tries   = 1;
    public $timeout = 30;
    public $taskid;
    // 上线,下线,发布的where条件
    protected $upWhere          = ['online_status' => 0, 'publish_down_status' => 1];
    protected $publishWhere     = ['online_status' => 1, 'publish_status'      => 0, 'async_result' => 1];
    protected $downWhere        = ['online_status' => 1];
    protected $publishDownWhere = ['online_status' => 0, 'publish_down_status' => 0];

    /**
     * Create a new job instance.
     *
     * @return void
     */
    public function __construct($option, $ids = '', $taskid = '')
    {
        $this->option = $option;
        $this->ids    = $ids;
        $this->taskid = $taskid;
    }

    /**
     * Execute the job.
     *
     * @return void
     */
    public function handle()
    {
        switch ($this->option[0]) {
            // 分发任务,将一个大任务划分为多个小任务
            case 'dispatch':
                $this->mydispatch($this->option[1]);
                break;
            // 上线小任务
            case 'up':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                Publication::updateMany(new Vchan(), $this->ids, [
                    'online_status'       => 1, 
                    'publish_down_status' => 0, 
                    'user_id'             => $user_id, 
                    'online_at'           => date('Y-m-d H:i:s')
                ]);
                Publication::updateOne(new Task(), $this->taskid, [
                    'done_num' => DB::raw('done_num +'.count($this->ids)),
                ]);
                break;
            // 发布小任务
            case 'publish':
                $publish_small_chunk_num = config('custom.base.job.vchan.publish_small_chunk_num');
                foreach ($this->ids->chunk($publish_small_chunk_num) as $chunk_ids) {
                    try {
                        // 获取媒资数据
                        $vchans  = Vchan::with(['vcposters', 'vccattags', 'vcstreams', 'vepgs'])
                            ->whereIn('id', $chunk_ids)->get();
                        // 处理媒资分类中间表数据, 并插入接口库
                        VchanVccattag::whereIn('vchan_id', $chunk_ids)->chunk($publish_small_chunk_num, function($vchanVcattags) {
                            $vchanVcattagDatas = self::makeVchanVccattags($vchanVcattags);
                            DB::connection('interface')->table('vchan_vccattags')->insert($vchanVcattagDatas);
                        });
                    } catch(\Exception $e) {
                        dd($e->getMessage());
                    }
                    // 拼装媒资数据, 产品包-媒资中间表数据
                    $vchan_datas = self::makeVchans($vchans);
                    DB::connection('interface')->beginTransaction();
                    try {
                        DB::connection('interface')->table('vchans')->insert($vchan_datas);
                        DB::connection('interface')->commit();
                        Publication::updateMany(new Vchan(), $chunk_ids, ['publish_status' => 1]);
                        Publication::updateOne(new Task(), $this->taskid, [
                            'done_num' => DB::raw('done_num + '.count($chunk_ids))
                        ]);
                    } catch (\Exception $e) {
                        DB::connection('interface')->rollback(); //事务回滚
                        dd($e->getMessage());
                    }
                }
                break;
            // 下线小任务
            case 'down':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                Publication::updateMany(new Vchan(), $this->ids, [
                    'online_status'  => 0, 
                    'publish_status' => 0, 
                    'user_id'        => $user_id, 
                    'offline_at'     => date('Y-m-d H:i:s')
                ]);
                Publication::updateOne(new Task(), $this->taskid, ['done_num' => DB::raw('done_num +' . count($this->ids))]);
                break;
            // 下线发布小任务
            case 'publishDown':
                $user_id = Publication::getField(new Task(), $this->taskid, 'user_id');
                Publication::deleteApi('vchans', 'vchan_id', $this->ids);
                Publication::deleteApi('vchan_vccattags', 'vchan_id', $this->ids);
                Publication::updateMany(new Vchan(), $this->ids, [
                    'publish_down_status' => 1, 
                    'user_id'             => $user_id,
                ]);
                Publication::updateOne(new Task(), $this->taskid, ['done_num' => DB::raw('done_num +' . count($this->ids))]);
                break;
        }
    }

    /**
    * 分发任务具体执行代码
    */
    public function mydispatch($option)
    {
        switch ($option) {
            case 'up':
                $chunk_num = config('custom.base.job.vchan.online_chunk_num');
                $where = $this->upWhere;
                break;
            case 'publish':
                $chunk_num = config('custom.base.job.vchan.publish_chunk_num');
                $where = $this->publishWhere;
                break;
            case 'down':
                $chunk_num = config('custom.base.job.vchan.offline_chunk_num');
                $where = $this->downWhere;
                break;
            case 'publishDown':
                $chunk_num = config('custom.base.job.vchan.publish_chunk_num');
                $where = $this->publishDownWhere;
                break;
        }
        Publication::chunk(new Vchan(), $this, $where, $chunk_num, [$option]);
    }

    /**
    * 拼装数据
    */
    public static function makeVchans($vchans)
    {
        $datas = [];
        $data  = [];
        foreach ($vchans as $vchan) {
            // 服务商ID 目前服务商ID是瀚动的
            $data['sp_id']         = 1;
            $data['vchan_id']      = $vchan->id;
            $data['title']         = $vchan->title;
            $data['subtitle']      = $vchan->subtitle;
            $data['long_desc']     = $vchan->long_desc;
            $data['short_desc']    = $vchan->short_desc;
            $data['async_content'] = $vchan->async_content;
            $data['vlogo']         = $vchan->vlogo;
            $data['expiring_at']   = $vchan->expiring_at;
            $data['start_at']      = $vchan->start_at;
            if ($vchan->vccattags->first()) {
                $data['tags'] = $vchan->vccattags->implode('id', '&');
            } else {
                $data['tags'] = '';
            }
            // 海报
            if ($vchan->vcposters->first()) {
                $data['vcposters'] = json_encode($vchan->vcposters);
            } else {
                $data['vcposters'] = '';
            }
            // 直播频道流
            if ($vchan->vcstreams->first()) {
                $data['vcstreams'] = json_encode($vchan->vcstreams);
            } else {
                $data['vcstreams'] = '';
            }
            $datas[] = $data;
        }
        return $datas;
    }

    /**
    * 拼装媒资分类中间表数据
    */
    public static function makeVchanVccattags($vchanVcattags)
    {
        $datas = [];
        $data  = [];
        foreach ($vchanVcattags as $vchanVcattag) {
            $data['vchan_id'] = $vchanVcattag->vchan_id;
            $data['vccattag_id'] = $vchanVcattag->vccattag_id;
            $datas[]            = $data;
        }
        return $datas;
    }
}
